Server load planning - Mailing list pgsql-general

From Dan Sugalski
Subject Server load planning
Date
Msg-id a06210202be6c9adc6c3e@[192.168.0.8]
Whole thread Raw
Responses Re: Server load planning  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-general
I'm trying to get a handle on how an app I'm looking to roll out's
going to impact the server I'm connecting to, and what sort of
capacity planning's going to be needed to make it all work relatively
well.

I'm looking at around 250-300 simultaneous users, nearly all of them
doing interactive work. (Curses-based screen stuff for the most part)
I'd not too worried about the server we've got for them being able to
handle that except... for reasons that are fairly annoying, I'm
looking at somewhere in excess of 9K simultaneous connections to the
database server, and I'm not in a position to cut that down any. (The
app suite's written in an old 4GL that assumes an ISAM database.
We're porting to a modern database and runtime, but we have to
preserve the DB semantics of the original database. Nasty, but there
you go)

I know each of the back-end processes is going to suck down some
resources on the server, but am I going to hit coordination or
inter-process sync delays with that many different back ends going at
once? (And is there a good way, short of just running some load
tests, to estimate the costs involved?)
--
                Dan

--------------------------------------it's like this-------------------
Dan Sugalski                          even samurai
dan@sidhe.org                         have teddy bears and even
                                       teddy bears get drunk

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Using sequence name depending on other column
Next
From: "Julian Scarfe"
Date:
Subject: Clustering system tables